use Test;

if exists (SELECT name From sysobjects WHERE xtype = 'u' and name = 'BlobTest')
begin
drop table dbo.BlobTest
end
Go

SELECT name From sysobjects WHERE type = 'u' -- get User table

SELECT name From sysobjects WHERE type = 'p' -- stored procedure>>>>>>> .r330
